/*
 Navicat Premium Dump SQL

 Source Server         : localhost_laradock
 Source Server Type    : MySQL
 Source Server Version : 80041 (8.0.41)
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 80041 (8.0.41)
 File Encoding         : 65001

 Date: 21/05/2025 11:35:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `config_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数名称',
  `config_key` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数键名',
  `config_value` longtext COLLATE utf8mb4_general_ci COMMENT '参数值',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除(0否 1是)',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='参数表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (1, '初始化密码', 'initPassword', '123456', '1', '2025-05-20 13:39:16', NULL, NULL, 0, '初始化密码');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dict_data_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_data_sort` int DEFAULT '0' COMMENT '字典排序',
  `dict_data_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '数据标签',
  `dict_data_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '数据键值',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '表格回显样式',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除(0否 1是)',
  PRIMARY KEY (`dict_data_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`dict_data_id`, `dict_data_sort`, `dict_data_name`, `dict_data_value`, `dict_type`, `css_class`, `list_class`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`) VALUES (1, 1, '男', '0', 'gender', '', 'processing', '1', '2025-05-20 13:19:33', '1', '2025-05-20 17:55:31', '男', 0);
INSERT INTO `sys_dict_data` (`dict_data_id`, `dict_data_sort`, `dict_data_name`, `dict_data_value`, `dict_type`, `css_class`, `list_class`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`) VALUES (2, 1, '女', '1', 'gender', '', 'success', '1', '2025-05-20 17:55:45', '', NULL, '女', 0);
INSERT INTO `sys_dict_data` (`dict_data_id`, `dict_data_sort`, `dict_data_name`, `dict_data_value`, `dict_type`, `css_class`, `list_class`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`) VALUES (3, 3, '未知', '2', 'gender', '', 'default', '1', '2025-05-20 17:56:01', '', NULL, '未知', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `dict_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
  `dict_code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典编码',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  PRIMARY KEY (`dict_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='字典表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_code`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (1, '性别', 'gender', '1', '2025-05-20 11:47:45', NULL, NULL, 0, '性别');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `cid` bigint NOT NULL DEFAULT '0' COMMENT '分类ID',
  `source` tinyint NOT NULL DEFAULT '1' COMMENT '来源（0用户 1后台）',
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '类型（1图片 2视频 3文件）',
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称',
  `uri` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除(0否 1是)',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者id',
  `create_time` datetime DEFAULT NULL COMMENT '新建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件表';

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 0, 1, 1, '682c23850f18be558a7cfd75.png', '/api/resources/local-plus/682c23850f18be558a7cfd75.png', 1, NULL, '1', '2025-05-20 14:39:02', '1', '2025-05-20 14:56:07');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, 0, 1, 2, '682c26630f18be558a7cfd76.mp4', '/api/resources/local-plus/682c26630f18be558a7cfd76.mp4', 1, NULL, '1', '2025-05-20 14:51:15', '1', '2025-05-20 14:51:19');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (3, 0, 1, 2, '682c26a80f18be558a7cfd77.mp4', '/api/resources/local-plus/682c26a80f18be558a7cfd77.mp4', 1, NULL, '1', '2025-05-20 14:52:25', '1', '2025-05-20 14:53:45');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (4, 0, 1, 3, '682c26b30f18be558a7cfd78.pdf', '/api/resources/local-plus/682c26b30f18be558a7cfd78.pdf', 0, NULL, '1', '2025-05-20 14:52:35', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (5, 0, 1, 3, '682c26b30f18be558a7cfd79.pdf', '/api/resources/local-plus/682c26b30f18be558a7cfd79.pdf', 0, NULL, '1', '2025-05-20 14:52:35', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (6, 0, 1, 3, '682c26b30f18be558a7cfd7a.pdf', '/api/resources/local-plus/682c26b30f18be558a7cfd7a.pdf', 0, NULL, '1', '2025-05-20 14:52:35', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (7, 0, 1, 2, '682c27340f18be558a7cfd7b.mp4', '/api/resources/local-plus/682c27340f18be558a7cfd7b.mp4', 1, NULL, '1', '2025-05-20 14:54:44', '1', '2025-05-20 14:56:14');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (8, 0, 1, 2, '682c28270f18be558a7cfd7c.mp4', '/api/resources/local-plus/682c28270f18be558a7cfd7c.mp4', 1, NULL, '1', '2025-05-20 14:58:48', '1', '2025-05-20 14:59:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (9, 0, 1, 2, '682c28340f18be558a7cfd7d.mp4', '/api/resources/local-plus/682c28340f18be558a7cfd7d.mp4', 1, NULL, '1', '2025-05-20 14:59:01', '1', '2025-05-20 14:59:07');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (10, 0, 1, 2, '682c28440f18be558a7cfd7e.mp4', '/api/resources/local-plus/682c28440f18be558a7cfd7e.mp4', 0, NULL, '1', '2025-05-20 14:59:17', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (11, 0, 1, 3, '682c28690f18be558a7cfd7f.xls', '/api/resources/local-plus/682c28690f18be558a7cfd7f.xls', 0, NULL, '1', '2025-05-20 14:59:53', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (12, 0, 1, 3, '682c28690f18be558a7cfd80.txt', '/api/resources/local-plus/682c28690f18be558a7cfd80.txt', 0, NULL, '1', '2025-05-20 14:59:53', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (13, 0, 1, 3, '682c28690f18be558a7cfd82.docx', '/api/resources/local-plus/682c28690f18be558a7cfd82.docx', 0, NULL, '1', '2025-05-20 14:59:53', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (14, 0, 1, 3, '682c28690f18be558a7cfd81.xlsx', '/api/resources/local-plus/682c28690f18be558a7cfd81.xlsx', 0, NULL, '1', '2025-05-20 14:59:53', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (15, 0, 1, 3, '682c28690f18be558a7cfd83.docx', '/api/resources/local-plus/682c28690f18be558a7cfd83.docx', 0, NULL, '1', '2025-05-20 14:59:54', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (16, 0, 1, 2, '682c289a0f18be558a7cfd84.mp4', '/api/resources/local-plus/682c289a0f18be558a7cfd84.mp4', 0, NULL, '1', '2025-05-20 15:00:42', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (17, 0, 1, 2, '682c28b80f18be558a7cfd85.mp4', '/api/resources/local-plus/682c28b80f18be558a7cfd85.mp4', 0, NULL, '1', '2025-05-20 15:01:12', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (18, 1, 1, 1, '682c2b0e0f18be558a7cfd86.jpg', '/api/resources/local-plus/682c2b0e0f18be558a7cfd86.jpg', 1, NULL, '1', '2025-05-20 15:11:11', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (19, 1, 1, 1, '682c2b460f18be558a7cfd87.jpg', '/api/resources/local-plus/682c2b460f18be558a7cfd87.jpg', 1, NULL, '1', '2025-05-20 15:12:06', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (20, 1, 1, 1, '682c2b790f18be558a7cfd88.jpg', '/api/resources/local-plus/682c2b790f18be558a7cfd88.jpg', 1, NULL, '1', '2025-05-20 15:12:58', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (21, 1, 1, 1, '682c2d290f18be558a7cfd89.jpg', '/api/resources/local-plus/682c2d290f18be558a7cfd89.jpg', 1, NULL, '1', '2025-05-20 15:20:09', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (22, 1, 1, 1, '682c2eb00f18be558a7cfd8a.jpg', '/api/resources/local-plus/682c2eb00f18be558a7cfd8a.jpg', 1, NULL, '1', '2025-05-20 15:26:40', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (23, 1, 1, 1, '682c2f8e0f18be558a7cfd8b.jpg', '/api/resources/local-plus/682c2f8e0f18be558a7cfd8b.jpg', 1, NULL, '1', '2025-05-20 15:30:23', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (24, 1, 1, 1, '682c2fbb0f18be558a7cfd8c.jpg', '/api/resources/local-plus/682c2fbb0f18be558a7cfd8c.jpg', 1, NULL, '1', '2025-05-20 15:31:07', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (25, 1, 1, 1, '682c2fdb0f18be558a7cfd8d.jpg', '/api/resources/local-plus/682c2fdb0f18be558a7cfd8d.jpg', 1, NULL, '1', '2025-05-20 15:31:40', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (26, 1, 1, 1, '682c2ff70f18be558a7cfd8e.jpg', '/api/resources/local-plus/682c2ff70f18be558a7cfd8e.jpg', 1, NULL, '1', '2025-05-20 15:32:07', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (27, 1, 1, 1, '682c303a0f18be558a7cfd8f.jpg', '/api/resources/local-plus/682c303a0f18be558a7cfd8f.jpg', 1, NULL, '1', '2025-05-20 15:33:14', '1', '2025-05-20 16:41:04');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (28, 0, 1, 1, '682c303f0f18be558a7cfd90.jpg', '/api/resources/local-plus/682c303f0f18be558a7cfd90.jpg', 1, NULL, '1', '2025-05-20 15:33:19', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (29, 0, 1, 1, '682c30520f18be558a7cfd91.jpg', '/api/resources/local-plus/682c30520f18be558a7cfd91.jpg', 1, NULL, '1', '2025-05-20 15:33:38', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (30, 0, 1, 1, '682c30690f18be558a7cfd92.jpg', '/api/resources/local-plus/682c30690f18be558a7cfd92.jpg', 1, NULL, '1', '2025-05-20 15:34:01', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (31, 0, 1, 1, '682c309f0f18be558a7cfd93.jpg', '/api/resources/local-plus/682c309f0f18be558a7cfd93.jpg', 1, NULL, '1', '2025-05-20 15:34:56', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (32, 0, 1, 1, '682c30a50f18be558a7cfd94.jpg', '/api/resources/local-plus/682c30a50f18be558a7cfd94.jpg', 1, NULL, '1', '2025-05-20 15:35:01', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (33, 0, 1, 1, '682c30b70f18be558a7cfd95.jpg', '/api/resources/local-plus/682c30b70f18be558a7cfd95.jpg', 1, NULL, '1', '2025-05-20 15:35:20', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (34, 0, 1, 1, '682c30cc0f18be558a7cfd96.jpg', '/api/resources/local-plus/682c30cc0f18be558a7cfd96.jpg', 1, NULL, '1', '2025-05-20 15:35:41', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (35, 0, 1, 1, '682c30da0f18be558a7cfd97.jpg', '/api/resources/local-plus/682c30da0f18be558a7cfd97.jpg', 1, NULL, '1', '2025-05-20 15:35:54', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (36, 0, 1, 1, '682c30e80f18be558a7cfd98.jpg', '/api/resources/local-plus/682c30e80f18be558a7cfd98.jpg', 1, NULL, '1', '2025-05-20 15:36:08', '1', '2025-05-20 16:40:58');
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (37, 0, 1, 1, '682c402a0f18be558a7cfd99.jpg', '/api/resources/local-plus/682c402a0f18be558a7cfd99.jpg', 0, NULL, '1', '2025-05-20 16:41:14', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (38, 0, 1, 1, '682c402a0f18be558a7cfd9a.jpg', '/api/resources/local-plus/682c402a0f18be558a7cfd9a.jpg', 0, NULL, '1', '2025-05-20 16:41:14', NULL, NULL);
INSERT INTO `sys_file` (`id`, `cid`, `source`, `type`, `name`, `uri`, `deleted`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (39, 0, 1, 1, '682c402a0f18be558a7cfd9b.jpg', '/api/resources/local-plus/682c402a0f18be558a7cfd9b.jpg', 0, NULL, '1', '2025-05-20 16:41:15', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_file_cate
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_cate`;
CREATE TABLE `sys_file_cate` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '文件类型（1图片 2视频 3文件）',
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '新建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='文件分类表';

-- ----------------------------
-- Records of sys_file_cate
-- ----------------------------
BEGIN;
INSERT INTO `sys_file_cate` (`id`, `type`, `name`, `remark`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 1, '分组一', NULL, 0, '1', '2025-05-20 14:22:12', '1', '2025-05-20 15:55:17');
INSERT INTO `sys_file_cate` (`id`, `type`, `name`, `remark`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, 1, '分组儿', NULL, 0, '1', '2025-05-20 16:33:39', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_name` varchar(64) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `ip_addr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录IP地址',
  `login_location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录地点',
  `browser` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器类型',
  `os` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `status` tinyint(1) DEFAULT NULL COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  PRIMARY KEY (`log_id`),
  KEY `status_index` (`status`) USING BTREE,
  KEY `login_time_index` (`login_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='登录日志';

-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (24, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 0, '登录成功', '2025-05-20 16:18:58');
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (25, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 0, '登录成功', '2025-05-20 17:54:42');
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (26, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 1, '用户名或密码错误', '2025-05-21 09:43:19');
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (27, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 0, '登录成功', '2025-05-21 09:43:22');
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (28, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 1, '用户名或密码错误', '2025-05-21 09:44:14');
INSERT INTO `sys_login_log` (`log_id`, `user_name`, `ip_addr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (29, 'admin', '127.0.0.1', '内网IP', 'Chrome 13', 'Mac OS X', 0, '登录成功', '2025-05-21 09:44:16');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件路径',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` tinyint DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` tinyint DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `route_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '路由名称',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (1, '系统管理', 0, 1, '', '', 'M', 0, 0, '', 'ep:setting', '1', '2025-02-12 08:06:07', '1', '2025-05-19 17:42:23', '系统管理目录', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (2, '菜单管理', 1, 1, 'system_menu', 'system/menu/index', 'C', 0, 0, NULL, 'carbon:decision-tree', '1', '2025-02-12 08:06:07', '1', '2025-05-08 09:00:12', '菜单管理', 0, 'system_menu');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (18, '角色管理', 1, 2, 'role', 'system/role/index', 'C', 0, 0, '', 'carbon:user-role', '1', '2025-03-24 09:13:57', '', NULL, '', 0, 'role');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (19, '新增', 18, 1, '', '', 'F', 0, 0, 'system:role:add', '', '1', '2025-03-25 09:05:49', '', NULL, '', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (20, '修改', 18, 2, '', '', 'F', 0, 0, 'system:role:edit', '', '1', '2025-03-25 09:06:03', '', NULL, '', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (21, '删除', 18, 3, '', '', 'F', 0, 0, 'system:role:delete', '', '1', '2025-03-25 09:06:15', '1', '2025-03-25 09:06:29', '', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (22, '查询', 18, 4, '', '', 'F', 0, 0, 'system:role:query', '', '1', '2025-03-25 09:06:26', '', NULL, '', 1, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (23, '分配角色', 18, 4, '', '', 'F', 0, 0, 'system:role:assing_roles', '', '1', '2025-03-25 09:18:15', '1', '2025-05-08 02:47:39', '', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (24, '测试页面', 1, 3, 'test', 'test', 'C', 0, 0, '', 'ep:watermelon', '1', '2025-03-26 01:53:17', '1', '2025-05-20 14:42:37', '', 0, 'test');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (25, '字典管理', 26, 3, 'dict', 'system/dict/index', 'C', 0, 0, '', 'material-symbols-light:dictionary-outline', '1', '2025-03-26 08:59:00', '1', '2025-04-28 06:38:16', '', 0, 'dict');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (26, '数据中心', 0, 2, '', '', 'M', 0, 0, '', 'tabler:database-cog', '1', '2025-04-09 14:32:27', '', NULL, '', 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (27, '字典数据', 26, 2, 'dict_data', 'system/dict/dict_data/index', 'C', 1, 0, '', '', '1', '2025-04-10 08:57:03', '', NULL, '', 1, 'dict_data');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (28, '字典数据', 26, 0, 'dict_data', 'system/dict/dict_data/index', 'C', 1, 0, '', '', '1', '2025-04-10 09:01:54', '', NULL, '', 1, 'dict_data');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (29, '参数设置', 26, 2, 'sys_config', 'system/config/index', 'C', 0, 0, '', 'carbon:parameter', '1', '2025-04-20 02:56:00', '', NULL, '', 0, 'sys_config');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (30, '通知公告', 26, 3, 'sys_notice', 'system/notice/index', 'C', 0, 0, '', 'ep:notification', '1', '2025-04-21 07:27:26', '', NULL, '', 0, 'sys_notice');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (31, '用户管理', 1, 0, 'user', 'system/user/index', 'C', 0, 0, '', 'fa6-solid:users', '1', '2025-05-06 05:12:46', '', NULL, '', 0, 'user');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (32, '新增', 2, 1, '', '', 'F', 0, 0, 'system:menu:add', '', '1', '2025-05-08 02:46:45', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (33, '修改', 2, 2, '', '', 'F', 0, 0, 'system:menu:edit', '', '1', '2025-05-08 02:46:56', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (34, '删除', 2, 3, '', '', 'F', 0, 0, 'system:menu:delete', '', '1', '2025-05-08 02:47:13', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (35, '新增字典', 25, 1, '', '', 'F', 0, 0, 'system:dict_type:add', '', '1', '2025-05-08 03:12:59', '1', '2025-05-08 03:13:13', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (36, '修改字典', 25, 2, '', '', 'F', 0, 0, 'system:dict_type:edit', '', '1', '2025-05-08 03:13:25', '1', '2025-05-08 03:14:03', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (37, '删除字典', 25, 3, '', '', 'F', 0, 0, 'system:dict_type:delete', '', '1', '2025-05-08 03:13:34', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (38, '新增字典值', 25, 4, '', '', 'F', 0, 0, 'system:dict_data:add', '', '1', '2025-05-08 03:13:59', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (39, '修改字典值', 25, 5, '', '', 'F', 0, 0, 'system:dict_data:edit', '', '1', '2025-05-08 03:14:15', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (40, '删除字典值', 25, 6, '', '', 'F', 0, 0, 'system:dict_data:delete', '', '1', '2025-05-08 03:14:26', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (41, '新增', 29, 1, '', '', 'F', 0, 0, 'system:config:add', '', '1', '2025-05-08 03:18:00', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (42, '修改', 29, 2, '', '', 'F', 0, 0, 'system:config:edit', '', '1', '2025-05-08 03:18:13', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (43, '删除', 29, 3, '', '', 'F', 0, 0, 'system:config:delete', '', '1', '2025-05-08 03:18:28', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (44, '新增', 30, 1, '', '', 'F', 0, 0, 'system:notice:add', '', '1', '2025-05-08 03:18:38', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (45, '修改', 30, 2, '', '', 'F', 0, 0, 'system:notice:edit', '', '1', '2025-05-08 03:18:54', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (46, '删除', 30, 3, '', '', 'F', 0, 0, 'system:notice:delete', '', '1', '2025-05-08 03:19:11', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (47, '素材中心', 26, 4, 'material', 'system/material/index', 'C', 0, 0, '', 'ep:files', '1', '2025-05-08 03:28:22', '', NULL, NULL, 0, 'material');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (48, '上传文件', 47, 1, '', '', 'F', 0, 0, 'system:file:upload', '', '1', '2025-05-08 03:29:19', '1', '2025-05-08 03:31:10', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (49, '移动文件', 47, 2, '', '', 'F', 0, 0, 'system:file:move', '', '1', '2025-05-08 03:29:31', '1', '2025-05-08 03:31:14', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (50, '重命名文件', 47, 3, '', '', 'F', 0, 0, 'system:file:rename', '', '1', '2025-05-08 03:29:45', '1', '2025-05-08 03:31:18', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (51, '删除文件', 47, 4, '', '', 'F', 0, 0, 'system:file:delete', '', '1', '2025-05-08 03:30:05', '1', '2025-05-08 03:31:21', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (52, '添加文件分类', 47, 5, '', '', 'F', 0, 0, 'system:file_cate:add', '', '1', '2025-05-08 03:31:06', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (53, '重命名文件分类', 47, 6, '', '', 'F', 0, 0, 'system:file_cate:rename', '', '1', '2025-05-08 03:31:41', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (54, '删除文件分类', 47, 7, '', '', 'F', 0, 0, 'system:file_cate:delete', '', '1', '2025-05-08 03:31:57', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (55, '新增', 31, 1, '', '', 'F', 0, 0, 'system:user:add', '', '1', '2025-05-08 04:00:03', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (56, '修改', 31, 2, '', '', 'F', 0, 0, 'system:user:edit', '', '1', '2025-05-08 05:15:51', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (57, '删除', 31, 3, '', '', 'F', 0, 0, 'system:user:delete', '', '1', '2025-05-08 05:16:02', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (58, '重置密码', 31, 4, '', '', 'F', 0, 0, 'system:user:resetpwd', '', '1', '2025-05-08 05:16:27', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (59, '分配角色', 31, 5, '', '', 'F', 0, 0, 'system:user:assign_roles', '', '1', '2025-05-08 05:16:49', '', NULL, NULL, 1, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (60, '个人中心', 31, 1, 'profile', 'system/user/profile', 'C', 1, 0, '', '', '1', '2025-05-08 07:39:34', '', NULL, NULL, 1, 'profile');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (61, '图标集', 26, 5, 'icons', 'system/icons/index', 'C', 0, 0, '', 'fa6-solid:icons', '1', '2025-05-09 07:29:45', '', NULL, NULL, 0, 'icons');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (62, '日志中心', 0, 4, '', '', 'M', 0, 0, '', 'fluent:send-logging-24-regular', '1', '2025-05-13 07:36:49', '1', '2025-05-13 07:38:57', NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (63, '登录日志', 62, 1, 'login_log', 'log/login', 'C', 0, 0, '', 'ep:check', '1', '2025-05-13 07:37:43', '1', '2025-05-15 13:35:29', NULL, 0, 'login_log');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (64, '删除', 63, 1, '', '', 'F', 0, 0, 'system:login_log:delete', '', '1', '2025-05-15 16:58:58', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (65, '清空', 63, 2, '', '', 'F', 0, 0, 'system:login_log:clear', '', '1', '2025-05-15 16:59:10', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (66, '操作日志', 62, 2, 'oper_log', 'log/oper', 'C', 0, 0, '', 'ep:operation', '1', '2025-05-16 16:16:08', '', NULL, NULL, 0, 'oper_log');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (67, '删除', 66, 1, '', '', 'F', 0, 0, 'system:oper_log:delete', '', '1', '2025-05-21 10:14:52', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (68, '清空', 66, 2, '', '', 'F', 0, 0, 'system:oper_log:clear', '', '1', '2025-05-21 10:15:07', '', NULL, NULL, 0, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `route_name`) VALUES (69, '详情', 66, 3, '', '', 'F', 0, 0, 'system:oper_log:detail', '', '1', '2025-05-21 10:15:25', '', NULL, NULL, 0, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题',
  `notice_type` tinyint NOT NULL DEFAULT '1' COMMENT '公告类型（1通知 2公告）',
  `notice_content` longtext COLLATE utf8mb4_general_ci COMMENT '公告内容',
  `status` tinyint(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
  `deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除（0否 1是）',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='通知公告表';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice` (`notice_id`, `notice_title`, `notice_type`, `notice_content`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`) VALUES (1, '通知关闭', 2, '<ul>\n<li>1</li>\n<li>2</li>\n<li>3</li>\n<li>4</li>\n<li>5</li>\n<li>6</li>\n</ul>', 0, '1', '2025-05-20 13:51:22', '1', '2025-05-20 13:52:22', '是啥', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模块标题',
  `oper_type` tinyint(1) DEFAULT '0' COMMENT '业务类型(0其它 1新增 2修改 3删除 4导出 5导入 6清空)',
  `method` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法名称',
  `req_method` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求方式',
  `oper_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作人员',
  `oper_url` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URL',
  `oper_ip` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求ip',
  `oper_location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作地点',
  `req_param` longtext COLLATE utf8mb4_general_ci COMMENT '请求参数',
  `rep_param` longtext COLLATE utf8mb4_general_ci COMMENT '响应参数',
  `status` tinyint(1) DEFAULT NULL COMMENT '操作状态（0正常 1异常）',
  `error_msg` longtext COLLATE utf8mb4_general_ci COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint DEFAULT '0' COMMENT '消耗时间',
  PRIMARY KEY (`oper_id`),
  KEY `oper_log_opt` (`oper_type`) USING BTREE,
  KEY `oper_log_s` (`status`) USING BTREE,
  KEY `oper_log_ot` (`oper_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='操作日志表';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (47, '删除操作日志', 3, 'com.example.demo.controller.system.SysOperLogController.delete()', 'DELETE', 'admin', '/system/sys_oper_log/delete/46', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:29:15', 17);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (48, '删除登录日志', 3, 'com.example.demo.controller.system.SysLoginLogController.delete()', 'DELETE', 'admin', '/system/sys_login_log/delete/23', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:29:26', 16);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (49, '新增文件分类', 1, 'com.example.demo.controller.system.SysFileCateController.insert()', 'POST', 'admin', '/system/sys_file_cate/insert', '127.0.0.1', '内网IP', '{\"id\":2,\"type\":1,\"name\":\"分组儿\",\"createBy\":\"1\",\"createTime\":1747730019225}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:33:39', 25);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (50, '文件移动', 2, 'com.example.demo.controller.system.SysFileController.move()', 'PUT', 'admin', '/system/sys_file/move/18,19,20,21,22,23,24,25,26,27', '127.0.0.1', '内网IP', '[18,19,20,21,22,23,24,25,26,27] {\"cid\":1,\"type\":1,\"name\":\"\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:40:49', 133);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (51, '文件删除', 3, 'com.example.demo.controller.system.SysFileController.delete()', 'DELETE', 'admin', '/system/sys_file/delete/28,29,30,31,32,33,34,35,36', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:40:58', 80);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (52, '文件删除', 3, 'com.example.demo.controller.system.SysFileController.delete()', 'DELETE', 'admin', '/system/sys_file/delete/18,19,20,21,22,23,24,25,26,27', '127.0.0.1', '内网IP', '{}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 16:41:04', 114);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (53, '修改字典值', 2, 'com.example.demo.controller.system.SysDictDataController.update()', 'PUT', 'admin', '/system/dict_data/update', '127.0.0.1', '内网IP', '{\"dictDataId\":1,\"dictDataSort\":\"1\",\"dictDataName\":\"男\",\"dictDataValue\":\"0\",\"dictType\":\"gender\",\"cssClass\":\"\",\"listClass\":\"processing\",\"createBy\":\"1\",\"createTime\":1747718373000,\"updateBy\":\"1\",\"updateTime\":1747734930501,\"deleted\":0,\"remark\":\"男\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 17:55:31', 28);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (54, '新增字典值', 1, 'com.example.demo.controller.system.SysDictDataController.insert()', 'POST', 'admin', '/system/dict_data/insert', '127.0.0.1', '内网IP', '{\"dictDataId\":2,\"dictDataSort\":\"1\",\"dictDataName\":\"女\",\"dictDataValue\":\"1\",\"dictType\":\"gender\",\"cssClass\":\"\",\"listClass\":\"success\",\"createBy\":\"1\",\"createTime\":1747734945167,\"remark\":\"女\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 17:55:45', 13);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (55, '新增字典值', 1, 'com.example.demo.controller.system.SysDictDataController.insert()', 'POST', 'admin', '/system/dict_data/insert', '127.0.0.1', '内网IP', '{\"dictDataId\":3,\"dictDataSort\":\"3\",\"dictDataName\":\"未知\",\"dictDataValue\":\"2\",\"dictType\":\"gender\",\"cssClass\":\"\",\"listClass\":\"default\",\"createBy\":\"1\",\"createTime\":1747734961045,\"remark\":\"未知\"}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-20 17:56:01', 16);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (56, '新增菜单', 1, 'com.example.demo.controller.system.SysMenuController.insert()', 'POST', 'admin', '/system/menu/insert', '127.0.0.1', '内网IP', '{\"menuId\":67,\"menuName\":\"删除\",\"parentId\":66,\"orderNum\":1,\"path\":\"\",\"component\":\"\",\"routeName\":\"\",\"menuType\":\"F\",\"visible\":0,\"status\":0,\"perms\":\"system:oper_log:delete\",\"icon\":\"\",\"createBy\":\"1\",\"createTime\":1747793692090}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-21 10:14:52', 57);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (57, '新增菜单', 1, 'com.example.demo.controller.system.SysMenuController.insert()', 'POST', 'admin', '/system/menu/insert', '127.0.0.1', '内网IP', '{\"menuId\":68,\"menuName\":\"清空\",\"parentId\":66,\"orderNum\":2,\"path\":\"\",\"component\":\"\",\"routeName\":\"\",\"menuType\":\"F\",\"visible\":0,\"status\":0,\"perms\":\"system:oper_log:clear\",\"icon\":\"\",\"createBy\":\"1\",\"createTime\":1747793706925}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-21 10:15:07', 13);
INSERT INTO `sys_oper_log` (`oper_id`, `title`, `oper_type`, `method`, `req_method`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `req_param`, `rep_param`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (58, '新增菜单', 1, 'com.example.demo.controller.system.SysMenuController.insert()', 'POST', 'admin', '/system/menu/insert', '127.0.0.1', '内网IP', '{\"menuId\":69,\"menuName\":\"详情\",\"parentId\":66,\"orderNum\":3,\"path\":\"\",\"component\":\"\",\"routeName\":\"\",\"menuType\":\"F\",\"visible\":0,\"status\":0,\"perms\":\"system:oper_log:detail\",\"icon\":\"\",\"createBy\":\"1\",\"createTime\":1747793725081}', '{\"msg\":\"操作成功\",\"code\":200}', 0, NULL, '2025-05-21 10:15:25', 18);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色编码',
  `role_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `role_code`, `role_name`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (1, 'super_admin', '超级管理员', '1', '2025-03-25 01:36:11', '1', '2025-03-25 01:36:11', 0, NULL);
INSERT INTO `sys_role` (`id`, `role_code`, `role_name`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (2, 'common', '普通角色', '1', '2025-05-20 09:37:17', '1', '2025-05-20 09:46:57', 1, NULL);
INSERT INTO `sys_role` (`id`, `role_code`, `role_name`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (3, 'common', '普通角色', '1', '2025-05-20 09:47:06', NULL, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` bigint NOT NULL COMMENT '角色id',
  `menu_ids` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单id',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_ids`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `remark`) VALUES (1, 3, '1,2,32,33,23', '1', '2025-05-20 09:54:54', '1', '2025-05-20 09:55:44', 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户昵称',
  `user_type` bigint NOT NULL DEFAULT '0' COMMENT '用户类型',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '手机号码',
  `sex` tinyint DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码',
  `status` tinyint DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `deleted` tinyint DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注',
  `is_root` tinyint NOT NULL DEFAULT '0' COMMENT '是否为超管(0否 1是)',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `is_root`) VALUES (1, 'admin', '张三', 0, 'zpaizw@163.com', '18812341234', 1, '/api/resources/local-plus/68118af80f1830c8b287512f.png', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, '', '2025-05-06 14:37:51', '1', '2025-05-20 11:21:53', NULL, 1);
INSERT INTO `sys_user` (`user_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `status`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `is_root`) VALUES (2, 'admins', 'admins', 0, 's@s.com', '18845647353', 2, '', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, '1', '2025-05-20 10:57:17', '1', '2025-05-20 11:12:03', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `deleted` tinyint DEFAULT '0' COMMENT '是否删除（0否 1是）',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` longtext COLLATE utf8mb4_general_ci COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户-角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 2, 3, 1, '1', '2025-05-20 10:57:17', NULL, NULL, NULL);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 2, 3, 1, '1', '2025-05-20 11:08:02', NULL, NULL, NULL);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, 2, 3, 1, '1', '2025-05-20 11:09:12', NULL, NULL, NULL);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `deleted`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, 2, 3, 0, '1', '2025-05-20 11:09:41', NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
